From 37bb5493b7571084e6d57aa45c5440dcb0db357e Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 15 Jul 2026 16:33:32 +0000 Subject: [PATCH] Resolve conversion problem #102 by making NULL times 00:00 --- conversion/clean.sql | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/conversion/clean.sql b/conversion/clean.sql index 05983f6..982dd82 100644 --- a/conversion/clean.sql +++ b/conversion/clean.sql @@ -567,3 +567,9 @@ UPDATE aggression_event UPDATE aggression_event SET ae_fol_b_focal_id = 'UNK' WHERE ae_fol_b_focal_id IS NULL; + + +-- Problem #102 +UPDATE aggression_event + SET ae_time = '00:00' + WHERE ae_time IS NULL; -- 2.34.1